<% ...... student_name=request.form("student_name") gender=request.form("gender") individual_resume=request.form("individual_resume") sql="insert into score_data((1),gender,individual_resume) values (' "&student_name&" ',' "&gender&" ',' "& "individual_resume&"')" conn.execute sql Response.Redirect("(2)") %> <body> <form id="form1" name="form1" method=" (3) "action="student_add.asp"> <p>姓名: <label for="student_name"></label> <input type=" (4) "> name="student_name" id="student_name" /> </p> <p>性别: <input name="gender" type=" (5) " id="radio" value="男" checked=" (6) " /> <label for="gender"></label>男 <input type="radio" name=" (7) " id="radio2" value="女" /> <label for="gender"></label>女</p> <p>个人简介: </p> <label for="individual_resume"></label> <(8)name="individual_resume" id="individual_resume" cols="60" rows="15"></textarea> <p> <input type="submit" name="button" id="button" value="提交" /> </p> </form> </body>
<body> <form action="result.asp" method="get" name="form1" target="_blank" id="form1"> <h2 align="center"></h2> <h2 align="center">成绩查询</h2> <p align="center">学号: <label for="student_number"></label> <input name="(9)" type="text" id="student_number" /> </p> <p align="center">姓名: <label for="student_name"></label> <input name="(10)" type="text" id="student_name" /> </p> <p align="center"> <input type="(11)" name="button" id="button" value="提交" /> </p> </form> </body>
<% ...... student_number=request.form("student_number") student_name=request.form("student_name") sql= "select * from (12) where student_number="& student_number &"'(13) student_name="’& student_name &"' " rs.open sql ,conn english_results="" math_results="" if not rs.eof() then english_results=rs("english_results") math_results=rs("math_results") end if ...... %> <body> <h2 align="center"><spong>查询结果</h2> <div width="500" border="1"> <p> <div><div align="center">学号</div></div> <div><div align="center">姓名</div></div> <div><div align="center">英语</div></div> <div><div align="center">数学</div></div> </p> <p> <div><divalign="center"><%=student_number%></div></div> <div><div align="center"><%=student_name%></div></div> <div><div align="center"><%=(14)%></div></div> <div><div align="center"><%=(15)%></div></div> </p> </div> </div> </body> </html>(15)备选答案: